﻿


  
using System;
using SubSonic;
using SubSonic.Schema;
using SubSonic.DataProviders;
using System.Data;

namespace Northwind.Data{
	public partial class NorthwindDB{

        public StoredProcedure CustOrderHist(){
            StoredProcedure sp=new StoredProcedure("CustOrderHist",this.Provider);
            return sp;
        }
        public StoredProcedure CustOrdersDetail(){
            StoredProcedure sp=new StoredProcedure("CustOrdersDetail",this.Provider);
            return sp;
        }
        public StoredProcedure CustOrdersOrders(){
            StoredProcedure sp=new StoredProcedure("CustOrdersOrders",this.Provider);
            return sp;
        }
        public StoredProcedure EmployeeSalesbyCountry(){
            StoredProcedure sp=new StoredProcedure("Employee Sales by Country",this.Provider);
            return sp;
        }
        public StoredProcedure SalesbyYear(){
            StoredProcedure sp=new StoredProcedure("Sales by Year",this.Provider);
            return sp;
        }
        public StoredProcedure SalesByCategory(){
            StoredProcedure sp=new StoredProcedure("SalesByCategory",this.Provider);
            return sp;
        }
        public StoredProcedure TenMostExpensiveProducts(){
            StoredProcedure sp=new StoredProcedure("Ten Most Expensive Products",this.Provider);
            return sp;
        }
	
	}
	
}
 